Version: 8.6.8.3

AccountConfigGateway

METADATA

Attribute	Value
Topic	5120-srse-gateway
MLink Token	ConfigGateway
Product	SRConfigGateway
accessType	SELECT,UPDATE,INSERT,DELETE
MLink Endpoint	MLink-Live

Table Definition

Field	Type	Key	Default Value	Comment
accnt	VARCHAR(16)	PRI	''
clientFirm	VARCHAR(16)	PRI	''
accountType	enum - AccountType		'None'	SR account type
omniAccnt	VARCHAR(16)		''	omnibus account if any must be an existing account with the same clientFirm and typeOmnibus
omniAccnt2	VARCHAR(16)		''	omnibus account if any must be an existing account with the same clientFirm and typeOmnibus
clientAccnt	VARCHAR(32)		''	client assigned long account string optional used to map between client and SR account strings
clientAccntIds	TEXT		''	comma separated list of alternate client defined accnt strings that all map to this accountConfig
clientTags	TEXT		''	optional user defined account tags eg tagtagtagtag max of 10000 total chars including seps
accntName	VARCHAR(32)		''	account name SR assigned
proxyFirm1	VARCHAR(16)		''	proxy firm 1
proxyFirm2	VARCHAR(16)		''	proxy firm 2
proxyFirm3	VARCHAR(16)		''	proxy firm 3
clientMPID	VARCHAR(4)		''
internalMPID	VARCHAR(4)		''
execBrkrCode	VARCHAR(16)		''
execBrkrAccountStk	VARCHAR(24)		''
execBrkrClFirmStk	VARCHAR(24)		''
execBrkrAccountFut	VARCHAR(24)		''
execBrkrClFirmFut	VARCHAR(24)		''
execBrkrAccountOpt	VARCHAR(24)		''
execBrkrClFirmOpt	VARCHAR(24)		''
reviewBrkrExDestStk	VARCHAR(24)		''
reviewBrkrExDestFut	VARCHAR(24)		''
reviewBrkrExDestOpt	VARCHAR(24)		''
execUserNameStk	VARCHAR(24)		''
execUserNameFut	VARCHAR(24)		''
execUserNameOpt	VARCHAR(24)		''
clearingFirmName	VARCHAR(24)		''	string name can be anything commonly used by position loaders not used in any FIX message
clearingFirmStk	VARCHAR(4)		''	stock clearing firm name or code books and records only visible in fix drop templates
clearingAccntStk	VARCHAR(16)		''	eg C233702
clearingFirmFut	VARCHAR(4)		''	futures clearing firm name or code books and records only visible in fix drop templates
clearingAccntFut	VARCHAR(16)		''	eg C233702
clearingFirmOpt	VARCHAR(4)		''	options clearing firm name or code books and records only visible in fix drop templates
clearingAccntOpt	VARCHAR(16)		''	eg C233701
clearingFlipTypeOpt	VARCHAR(16)		''
clearingFlipFirmOpt	VARCHAR(16)		''
clearingFlipAccntOpt	VARCHAR(16)		''
stkPositionSrc	enum - PositionSource		'None'
futPositionSrc	enum - PositionSource		'None'
optPositionSrc	enum - PositionSource		'None'
theoModel	VARCHAR(16)		''	theo model primary
theoModel2	VARCHAR(16)		''	theo model 2
priStkAggGroup	VARCHAR(16)		''	primary stk grouping code for computing aggregate positions default ClientFirm
secStkAggGroup	VARCHAR(16)		''	secondary stk grouping code for computing aggregate positions default
optAggGroup	VARCHAR(16)		''	opt grouping code for computing aggregate positions default ClientFirm
futAggGroup	VARCHAR(16)		''	fut grouping code for computing aggregate positions default ClientFirm
accntColor	VARCHAR(16)		''
accntStatus	enum - AccntStatus		'None'	This accounts current status
defaultTradingAccnt	VARCHAR(16)		''	our typeRollup default trading accnt must be typeTrading if ticker not found in AltSymbolMap
mifidAccntId	VARCHAR(16)		''	MIFID account identifier
catFdidOpenDate	DATE		'1900-01-01'	CAT FDID OpenDate
noCrossGroup	VARCHAR(16)		''	no cross grouping code accounts with the same nCrossGroup will not cross with themselves default ClientFirm
hedgeDeltaRule	enum - HedgeDeltaRule		'None'	HedgeDelta Source IVol use SR implied surface sticky strike IvS use SR surface dynamic TVol use user supplied theo surface sticky strike TvS use user supplied theo surface dynamic AccountConfighedgeDelta
binaryDays	FLOAT		0	used to force delta calcs binary prior to expiration
awayExecControl	enum - AwayExecControl		'None'	Whether to include Away Executions in EE risk counters
riskGroupControl	enum - RiskGroupControl		'None'	enables enhanced risk group controls ParentCapn means each parent order can be at most 1n of the risk group limit StrictLimits implies PC4
isAtsEnabled	enum - YesNo		'None'
clrFlipEnabled	enum - YesNo		'None'	used to enable brokerdealers to send agency clearing ClrFlip instructions on parent orders
stageReview	enum - StageReview		'None'	Strict will rereview user changes Normal will rereview size incr only
reviewExDest	VARCHAR(16)		''	order routing string if any StageReview Orders
userMarking	enum - YesNo		'None'	users are required to do the longshort marking on orders
requireLocate	enum - RequireLocate		'None'	locate check enforced in SR systems
locateFirm	VARCHAR(6)		''	locate firm must be one of the items in the clientFirmConfigLocatePool list
locatePool	VARCHAR(16)		''	locate pool firm granting the locate
firmType	enum - FirmType		'None'
orderCapacity	enum - OrderCapacity		'None'	Order capacity
custOrderCapacity	enum - OrderCapacity		'None'	Order capacity of Account at Customers Firm
futClearingRange	enum - FutClearingRange		'None'
futCustType	enum - FutCustType		'None'
catReportable	enum - CatReportType		'None'	CAT reportable type
catAccnt	VARCHAR(40)		''	CAT Firm Designated ID
catBrkrAccnt	VARCHAR(40)		''	Brkrs CAT Firm Designated ID
catBrkrAccntType	enum - CatAccntType		'None'	CAT account holder type
catBrkrFirmType	enum - CatFirmType		'None'	CAT source firm type
catBrkrIMID	VARCHAR(16)		''	BD firm FDID only if client is a BD supplied by FINRA fbo client
tiedPriceRounding	enum - TiedPriceRounding		'Loose'	option limit price rounding rule Loose up to 14 tick extra Strict never exceed limit
algoFlashPct	TINYINT UNSIGNED		0	percent of orders for which algo will start flash auctions 0 100
algoBlockPct	TINYINT UNSIGNED		0	percent of orders for which algo will start block auctions 0 100
auctionResponder	enum - AuctionResponder		'None'	can respond to exchange away auctions
takeExchList	TINYTEXT		''	exchange order for marketable orders eg BATSNYSECBOE
makeExchList	TINYTEXT		''	exchange order for nonmarketable orders eg BATSNYSECBOE
incTakeExchFee	enum - IncExchFee		'None'	include exchange fee in limit calculations
incMakeExchFee	enum - IncExchFee		'None'	include exchange fee in limit calculations
makeExchRule	enum - MakeExchRule		'None'	ActiveMaker exchange preference rule MaxPart will pick exchanges to maximize participation FeeOrder will pick exchanges to minimize fees maximize rebates ImprvOnly will only make when improving NBBO
roundRule	enum - RoundRule		'None'	Stock Price Rounding rule Fuzzy 90 Exact 100
execMode	enum - ExecMode		'None'
cxlOnHalt	enum - YesNo		'None'	cancel parent orders if the item being traded or underlier is halted
splitZero	enum - YesNo		'None'	sell stock down to zero before selling short
betaSource	enum - BetaSource		'None'
billingSchedule	VARCHAR(16)		''	overrides billingSchedule at clientFirm level
routeTemplates	TEXT		''	comma separated list of AccountRouteConfigTemplate IDs
accountConfigRiskTemplate	VARCHAR(32)		''	AccountConfigRiskTemplate ID
ExchGroupCapStratTemplateNmsEqt	VARCHAR(32)		''	AccountExchGroupCapStratTemplate ID for NMS EQT configs CapStrategyTable
ExchGroupCapStratTemplateNmsOpt	VARCHAR(32)		''	AccountExchGroupCapStratTemplate ID for NMS OPT configs CapStrategyTable
ExchGroupCapStratTemplateCmxFut	VARCHAR(32)		''	AccountExchGroupCapStratTemplate ID for CMX FUT configs CapStrategyTable
ExchGroupRteTemplateNmsEqt	VARCHAR(32)		''	AccountExchGroupRteTableTemplate ID For NMS EQT configs AccountRouteTable
ExchGroupRteTemplateNmsOpt	VARCHAR(32)		''	AccountExchGroupRteTableTemplate ID for NMS OPT configs AccountRouteTable
ExchGroupRteTemplateCmxFut	VARCHAR(32)		''	AccountExchGroupRteTableTemplate ID for CMX FUT configs AccountRouteTable

PRIMARY KEY DEFINITION (Unique)

Field	Sequence
accnt	1
clientFirm	2

SELECT TABLE EXAMPLE QUERY

SELECT *
FROM `SRConfigGateway`.`MsgAccountConfigGateway`
WHERE 
    /* Replace with a VARCHAR(16) */ 
    `accnt` = 'Example_accnt'
  AND
    /* Replace with a VARCHAR(16) */ 
    `clientFirm` = 'Example_clientFirm';

UPDATE TABLE EXAMPLE QUERY

UPDATE `SRConfigGateway`.`MsgAccountConfigGateway` 
SET
    /* Replace with a ENUM('None','Normal','Strategy','Clearing','Rollup','Omnibus','Reconcile') */ 
    `accountType` = 'None',
    /* Replace with a VARCHAR(16) */ 
    `omniAccnt` = 'Example_omniAccnt',
    /* Replace with a VARCHAR(16) */ 
    `omniAccnt2` = 'Example_omniAccnt2',
    /* Replace with a VARCHAR(32) */ 
    `clientAccnt` = 'Example_clientAccnt',
    /* Replace with a TEXT */ 
    `clientAccntIds` = 'dummy text',
    /* Replace with a TEXT */ 
    `clientTags` = 'dummy text',
    /* Replace with a VARCHAR(32) */ 
    `accntName` = 'Example_accntName',
    /* Replace with a VARCHAR(16) */ 
    `proxyFirm1` = 'Example_proxyFirm1',
    /* Replace with a VARCHAR(16) */ 
    `proxyFirm2` = 'Example_proxyFirm2',
    /* Replace with a VARCHAR(16) */ 
    `proxyFirm3` = 'Example_proxyFirm3',
    /* Replace with a VARCHAR(4) */ 
    `clientMPID` = 'Example_clientMPID',
    /* Replace with a VARCHAR(4) */ 
    `internalMPID` = 'Example_internalMPID',
    /* Replace with a VARCHAR(16) */ 
    `execBrkrCode` = 'Example_execBrkrCode',
    /* Replace with a VARCHAR(24) */ 
    `execBrkrAccountStk` = 'Example_execBrkrAccountStk',
    /* Replace with a VARCHAR(24) */ 
    `execBrkrClFirmStk` = 'Example_execBrkrClFirmStk',
    /* Replace with a VARCHAR(24) */ 
    `execBrkrAccountFut` = 'Example_execBrkrAccountFut',
    /* Replace with a VARCHAR(24) */ 
    `execBrkrClFirmFut` = 'Example_execBrkrClFirmFut',
    /* Replace with a VARCHAR(24) */ 
    `execBrkrAccountOpt` = 'Example_execBrkrAccountOpt',
    /* Replace with a VARCHAR(24) */ 
    `execBrkrClFirmOpt` = 'Example_execBrkrClFirmOpt',
    /* Replace with a VARCHAR(24) */ 
    `reviewBrkrExDestStk` = 'Example_reviewBrkrExDestStk',
    /* Replace with a VARCHAR(24) */ 
    `reviewBrkrExDestFut` = 'Example_reviewBrkrExDestFut',
    /* Replace with a VARCHAR(24) */ 
    `reviewBrkrExDestOpt` = 'Example_reviewBrkrExDestOpt',
    /* Replace with a VARCHAR(24) */ 
    `execUserNameStk` = 'Example_execUserNameStk',
    /* Replace with a VARCHAR(24) */ 
    `execUserNameFut` = 'Example_execUserNameFut',
    /* Replace with a VARCHAR(24) */ 
    `execUserNameOpt` = 'Example_execUserNameOpt',
    /* Replace with a VARCHAR(24) */ 
    `clearingFirmName` = 'Example_clearingFirmName',
    /* Replace with a VARCHAR(4) */ 
    `clearingFirmStk` = 'Example_clearingFirmStk',
    /* Replace with a VARCHAR(16) */ 
    `clearingAccntStk` = 'Example_clearingAccntStk',
    /* Replace with a VARCHAR(4) */ 
    `clearingFirmFut` = 'Example_clearingFirmFut',
    /* Replace with a VARCHAR(16) */ 
    `clearingAccntFut` = 'Example_clearingAccntFut',
    /* Replace with a VARCHAR(4) */ 
    `clearingFirmOpt` = 'Example_clearingFirmOpt',
    /* Replace with a VARCHAR(16) */ 
    `clearingAccntOpt` = 'Example_clearingAccntOpt',
    /* Replace with a VARCHAR(16) */ 
    `clearingFlipTypeOpt` = 'Example_clearingFlipTypeOpt',
    /* Replace with a VARCHAR(16) */ 
    `clearingFlipFirmOpt` = 'Example_clearingFlipFirmOpt',
    /* Replace with a VARCHAR(16) */ 
    `clearingFlipAccntOpt` = 'Example_clearingFlipAccntOpt',
    /* Replace with a ENUM('None','Zero','SR','CLR','CLR_SR') */ 
    `stkPositionSrc` = 'None',
    /* Replace with a ENUM('None','Zero','SR','CLR','CLR_SR') */ 
    `futPositionSrc` = 'None',
    /* Replace with a ENUM('None','Zero','SR','CLR','CLR_SR') */ 
    `optPositionSrc` = 'None',
    /* Replace with a VARCHAR(16) */ 
    `theoModel` = 'Example_theoModel',
    /* Replace with a VARCHAR(16) */ 
    `theoModel2` = 'Example_theoModel2',
    /* Replace with a VARCHAR(16) */ 
    `priStkAggGroup` = 'Example_priStkAggGroup',
    /* Replace with a VARCHAR(16) */ 
    `secStkAggGroup` = 'Example_secStkAggGroup',
    /* Replace with a VARCHAR(16) */ 
    `optAggGroup` = 'Example_optAggGroup',
    /* Replace with a VARCHAR(16) */ 
    `futAggGroup` = 'Example_futAggGroup',
    /* Replace with a VARCHAR(16) */ 
    `accntColor` = 'Example_accntColor',
    /* Replace with a ENUM('None','Suspended','Active','Frozen','Pending') */ 
    `accntStatus` = 'None',
    /* Replace with a VARCHAR(16) */ 
    `defaultTradingAccnt` = 'Example_defaultTradingAccnt',
    /* Replace with a VARCHAR(16) */ 
    `mifidAccntId` = 'Example_mifidAccntId',
    /* Replace with a DATE */
    `catFdidOpenDate` = '2022-01-01',
    /* Replace with a VARCHAR(16) */ 
    `noCrossGroup` = 'Example_noCrossGroup',
    /* Replace with a ENUM('None','IVol','IvS','TVol','TvS','Binary','IvS_25','IvS_50','IvS_75','TvAll','TvAllS') */ 
    `hedgeDeltaRule` = 'None',
    /* Replace with a FLOAT */ 
    `binaryDays` = 1.23,
    /* Replace with a ENUM('None','IncludeAll') */ 
    `awayExecControl` = 'None',
    /* Replace with a ENUM('None','StrictLimits','ParentCap2','ParentCap3','ParentCap4','Uncapped') */ 
    `riskGroupControl` = 'None',
    /* Replace with a ENUM('None','Yes','No') */ 
    `isAtsEnabled` = 'None',
    /* Replace with a ENUM('None','Yes','No') */ 
    `clrFlipEnabled` = 'None',
    /* Replace with a ENUM('None','Strict','Normal') */ 
    `stageReview` = 'None',
    /* Replace with a VARCHAR(16) */ 
    `reviewExDest` = 'Example_reviewExDest',
    /* Replace with a ENUM('None','Yes','No') */ 
    `userMarking` = 'None',
    /* Replace with a ENUM('None','Yes','No','Manual','MM','StageReview','Soft') */ 
    `requireLocate` = 'None',
    /* Replace with a VARCHAR(6) */ 
    `locateFirm` = 'Example_locateFirm',
    /* Replace with a VARCHAR(16) */ 
    `locatePool` = 'Example_locatePool',
    /* Replace with a ENUM('None','Customer','Firm','MarketMaker','ProCustomer','BrokerDealer','AwayMM','FirmJBO','BrkrDlrCust') */ 
    `firmType` = 'None',
    /* Replace with a ENUM('None','Agency','Principal','Individual','Proprietary','AgentOtherMember','RisklessPrincipal','MarketMaker') */ 
    `orderCapacity` = 'None',
    /* Replace with a ENUM('None','Agency','Principal','Individual','Proprietary','AgentOtherMember','RisklessPrincipal','MarketMaker') */ 
    `custOrderCapacity` = 'None',
    /* Replace with a ENUM('None','Customer','Firm') */ 
    `futClearingRange` = 'None',
    /* Replace with a ENUM('None','IndividualMember','PropMember','OtherMember','NonMember') */ 
    `futCustType` = 'None',
    /* Replace with a ENUM('None','All','Stock','Options') */ 
    `catReportable` = 'None',
    /* Replace with a VARCHAR(40) */ 
    `catAccnt` = 'Example_catAccnt',
    /* Replace with a VARCHAR(40) */ 
    `catBrkrAccnt` = 'Example_catBrkrAccnt',
    /* Replace with a ENUM('None','Institutional','Employee','Foreign','Individual','MktMaking','FirmAvgPx','OtherProp','Error') */ 
    `catBrkrAccntType` = 'None',
    /* Replace with a ENUM('None','Client','ClientBDAgency','ClientBDFirm','SRFirm') */ 
    `catBrkrFirmType` = 'None',
    /* Replace with a VARCHAR(16) */ 
    `catBrkrIMID` = 'Example_catBrkrIMID',
    /* Replace with a ENUM('Loose','Strict') */ 
    `tiedPriceRounding` = 'Loose',
    /* Replace with a TINYINT UNSIGNED */ 
    `algoFlashPct` = 1,
    /* Replace with a TINYINT UNSIGNED */ 
    `algoBlockPct` = 1,
    /* Replace with a ENUM('None','Any','Disable') */ 
    `auctionResponder` = 'None',
    /* Replace with a TINYTEXT */ 
    `takeExchList` = 'dummy tiny text',
    /* Replace with a TINYTEXT */ 
    `makeExchList` = 'dummy tiny text',
    /* Replace with a ENUM('None','ExclFee','IncFee') */ 
    `incTakeExchFee` = 'None',
    /* Replace with a ENUM('None','ExclFee','IncFee') */ 
    `incMakeExchFee` = 'None',
    /* Replace with a ENUM('None','MaxPart','FeeOptimal','ImprvOnly','FeeStrict','RoundRobin','ProRataOptim') */ 
    `makeExchRule` = 'None',
    /* Replace with a ENUM('None','Exact','Fuzzy') */ 
    `roundRule` = 'None',
    /* Replace with a ENUM('None','OptimizePnL','OptimizeFees') */ 
    `execMode` = 'None',
    /* Replace with a ENUM('None','Yes','No') */ 
    `cxlOnHalt` = 'None',
    /* Replace with a ENUM('None','Yes','No') */ 
    `splitZero` = 'None',
    /* Replace with a ENUM('None','betaSPX','betaQQQ','betaIWM','clientBeta') */ 
    `betaSource` = 'None',
    /* Replace with a VARCHAR(16) */ 
    `billingSchedule` = 'Example_billingSchedule',
    /* Replace with a TEXT */ 
    `routeTemplates` = 'dummy text',
    /* Replace with a VARCHAR(32) */ 
    `accountConfigRiskTemplate` = 'Example_accountConfigRiskTemplate',
    /* Replace with a VARCHAR(32) */ 
    `ExchGroupCapStratTemplateNmsEqt` = 'Example_ExchGroupCapStratTemplateNmsEqt',
    /* Replace with a VARCHAR(32) */ 
    `ExchGroupCapStratTemplateNmsOpt` = 'Example_ExchGroupCapStratTemplateNmsOpt',
    /* Replace with a VARCHAR(32) */ 
    `ExchGroupCapStratTemplateCmxFut` = 'Example_ExchGroupCapStratTemplateCmxFut',
    /* Replace with a VARCHAR(32) */ 
    `ExchGroupRteTemplateNmsEqt` = 'Example_ExchGroupRteTemplateNmsEqt',
    /* Replace with a VARCHAR(32) */ 
    `ExchGroupRteTemplateNmsOpt` = 'Example_ExchGroupRteTemplateNmsOpt',
    /* Replace with a VARCHAR(32) */ 
    `ExchGroupRteTemplateCmxFut` = 'Example_ExchGroupRteTemplateCmxFut'
WHERE
    /* Replace with a VARCHAR(16) */ 
    `accnt` = 'Example_accnt'
  AND
    /* Replace with a VARCHAR(16) */ 
    `clientFirm` = 'Example_clientFirm';

INSERT TABLE EXAMPLE QUERY

INSERT INTO `SRConfigGateway`.`MsgAccountConfigGateway`(
    /* Replace with a VARCHAR(16) */ 
    `accnt`,
    /* Replace with a VARCHAR(16) */ 
    `clientFirm`,
    /* Replace with a ENUM('None','Normal','Strategy','Clearing','Rollup','Omnibus','Reconcile') */ 
    `accountType`,
    /* Replace with a VARCHAR(16) */ 
    `omniAccnt`,
    /* Replace with a VARCHAR(16) */ 
    `omniAccnt2`,
    /* Replace with a VARCHAR(32) */ 
    `clientAccnt`,
    /* Replace with a TEXT */ 
    `clientAccntIds`,
    /* Replace with a TEXT */ 
    `clientTags`,
    /* Replace with a VARCHAR(32) */ 
    `accntName`,
    /* Replace with a VARCHAR(16) */ 
    `proxyFirm1`,
    /* Replace with a VARCHAR(16) */ 
    `proxyFirm2`,
    /* Replace with a VARCHAR(16) */ 
    `proxyFirm3`,
    /* Replace with a VARCHAR(4) */ 
    `clientMPID`,
    /* Replace with a VARCHAR(4) */ 
    `internalMPID`,
    /* Replace with a VARCHAR(16) */ 
    `execBrkrCode`,
    /* Replace with a VARCHAR(24) */ 
    `execBrkrAccountStk`,
    /* Replace with a VARCHAR(24) */ 
    `execBrkrClFirmStk`,
    /* Replace with a VARCHAR(24) */ 
    `execBrkrAccountFut`,
    /* Replace with a VARCHAR(24) */ 
    `execBrkrClFirmFut`,
    /* Replace with a VARCHAR(24) */ 
    `execBrkrAccountOpt`,
    /* Replace with a VARCHAR(24) */ 
    `execBrkrClFirmOpt`,
    /* Replace with a VARCHAR(24) */ 
    `reviewBrkrExDestStk`,
    /* Replace with a VARCHAR(24) */ 
    `reviewBrkrExDestFut`,
    /* Replace with a VARCHAR(24) */ 
    `reviewBrkrExDestOpt`,
    /* Replace with a VARCHAR(24) */ 
    `execUserNameStk`,
    /* Replace with a VARCHAR(24) */ 
    `execUserNameFut`,
    /* Replace with a VARCHAR(24) */ 
    `execUserNameOpt`,
    /* Replace with a VARCHAR(24) */ 
    `clearingFirmName`,
    /* Replace with a VARCHAR(4) */ 
    `clearingFirmStk`,
    /* Replace with a VARCHAR(16) */ 
    `clearingAccntStk`,
    /* Replace with a VARCHAR(4) */ 
    `clearingFirmFut`,
    /* Replace with a VARCHAR(16) */ 
    `clearingAccntFut`,
    /* Replace with a VARCHAR(4) */ 
    `clearingFirmOpt`,
    /* Replace with a VARCHAR(16) */ 
    `clearingAccntOpt`,
    /* Replace with a VARCHAR(16) */ 
    `clearingFlipTypeOpt`,
    /* Replace with a VARCHAR(16) */ 
    `clearingFlipFirmOpt`,
    /* Replace with a VARCHAR(16) */ 
    `clearingFlipAccntOpt`,
    /* Replace with a ENUM('None','Zero','SR','CLR','CLR_SR') */ 
    `stkPositionSrc`,
    /* Replace with a ENUM('None','Zero','SR','CLR','CLR_SR') */ 
    `futPositionSrc`,
    /* Replace with a ENUM('None','Zero','SR','CLR','CLR_SR') */ 
    `optPositionSrc`,
    /* Replace with a VARCHAR(16) */ 
    `theoModel`,
    /* Replace with a VARCHAR(16) */ 
    `theoModel2`,
    /* Replace with a VARCHAR(16) */ 
    `priStkAggGroup`,
    /* Replace with a VARCHAR(16) */ 
    `secStkAggGroup`,
    /* Replace with a VARCHAR(16) */ 
    `optAggGroup`,
    /* Replace with a VARCHAR(16) */ 
    `futAggGroup`,
    /* Replace with a VARCHAR(16) */ 
    `accntColor`,
    /* Replace with a ENUM('None','Suspended','Active','Frozen','Pending') */ 
    `accntStatus`,
    /* Replace with a VARCHAR(16) */ 
    `defaultTradingAccnt`,
    /* Replace with a VARCHAR(16) */ 
    `mifidAccntId`,
    /* Replace with a DATE */
    `catFdidOpenDate`,
    /* Replace with a VARCHAR(16) */ 
    `noCrossGroup`,
    /* Replace with a ENUM('None','IVol','IvS','TVol','TvS','Binary','IvS_25','IvS_50','IvS_75','TvAll','TvAllS') */ 
    `hedgeDeltaRule`,
    /* Replace with a FLOAT */ 
    `binaryDays`,
    /* Replace with a ENUM('None','IncludeAll') */ 
    `awayExecControl`,
    /* Replace with a ENUM('None','StrictLimits','ParentCap2','ParentCap3','ParentCap4','Uncapped') */ 
    `riskGroupControl`,
    /* Replace with a ENUM('None','Yes','No') */ 
    `isAtsEnabled`,
    /* Replace with a ENUM('None','Yes','No') */ 
    `clrFlipEnabled`,
    /* Replace with a ENUM('None','Strict','Normal') */ 
    `stageReview`,
    /* Replace with a VARCHAR(16) */ 
    `reviewExDest`,
    /* Replace with a ENUM('None','Yes','No') */ 
    `userMarking`,
    /* Replace with a ENUM('None','Yes','No','Manual','MM','StageReview','Soft') */ 
    `requireLocate`,
    /* Replace with a VARCHAR(6) */ 
    `locateFirm`,
    /* Replace with a VARCHAR(16) */ 
    `locatePool`,
    /* Replace with a ENUM('None','Customer','Firm','MarketMaker','ProCustomer','BrokerDealer','AwayMM','FirmJBO','BrkrDlrCust') */ 
    `firmType`,
    /* Replace with a ENUM('None','Agency','Principal','Individual','Proprietary','AgentOtherMember','RisklessPrincipal','MarketMaker') */ 
    `orderCapacity`,
    /* Replace with a ENUM('None','Agency','Principal','Individual','Proprietary','AgentOtherMember','RisklessPrincipal','MarketMaker') */ 
    `custOrderCapacity`,
    /* Replace with a ENUM('None','Customer','Firm') */ 
    `futClearingRange`,
    /* Replace with a ENUM('None','IndividualMember','PropMember','OtherMember','NonMember') */ 
    `futCustType`,
    /* Replace with a ENUM('None','All','Stock','Options') */ 
    `catReportable`,
    /* Replace with a VARCHAR(40) */ 
    `catAccnt`,
    /* Replace with a VARCHAR(40) */ 
    `catBrkrAccnt`,
    /* Replace with a ENUM('None','Institutional','Employee','Foreign','Individual','MktMaking','FirmAvgPx','OtherProp','Error') */ 
    `catBrkrAccntType`,
    /* Replace with a ENUM('None','Client','ClientBDAgency','ClientBDFirm','SRFirm') */ 
    `catBrkrFirmType`,
    /* Replace with a VARCHAR(16) */ 
    `catBrkrIMID`,
    /* Replace with a ENUM('Loose','Strict') */ 
    `tiedPriceRounding`,
    /* Replace with a TINYINT UNSIGNED */ 
    `algoFlashPct`,
    /* Replace with a TINYINT UNSIGNED */ 
    `algoBlockPct`,
    /* Replace with a ENUM('None','Any','Disable') */ 
    `auctionResponder`,
    /* Replace with a TINYTEXT */ 
    `takeExchList`,
    /* Replace with a TINYTEXT */ 
    `makeExchList`,
    /* Replace with a ENUM('None','ExclFee','IncFee') */ 
    `incTakeExchFee`,
    /* Replace with a ENUM('None','ExclFee','IncFee') */ 
    `incMakeExchFee`,
    /* Replace with a ENUM('None','MaxPart','FeeOptimal','ImprvOnly','FeeStrict','RoundRobin','ProRataOptim') */ 
    `makeExchRule`,
    /* Replace with a ENUM('None','Exact','Fuzzy') */ 
    `roundRule`,
    /* Replace with a ENUM('None','OptimizePnL','OptimizeFees') */ 
    `execMode`,
    /* Replace with a ENUM('None','Yes','No') */ 
    `cxlOnHalt`,
    /* Replace with a ENUM('None','Yes','No') */ 
    `splitZero`,
    /* Replace with a ENUM('None','betaSPX','betaQQQ','betaIWM','clientBeta') */ 
    `betaSource`,
    /* Replace with a VARCHAR(16) */ 
    `billingSchedule`,
    /* Replace with a TEXT */ 
    `routeTemplates`,
    /* Replace with a VARCHAR(32) */ 
    `accountConfigRiskTemplate`,
    /* Replace with a VARCHAR(32) */ 
    `ExchGroupCapStratTemplateNmsEqt`,
    /* Replace with a VARCHAR(32) */ 
    `ExchGroupCapStratTemplateNmsOpt`,
    /* Replace with a VARCHAR(32) */ 
    `ExchGroupCapStratTemplateCmxFut`,
    /* Replace with a VARCHAR(32) */ 
    `ExchGroupRteTemplateNmsEqt`,
    /* Replace with a VARCHAR(32) */ 
    `ExchGroupRteTemplateNmsOpt`,
    /* Replace with a VARCHAR(32) */ 
    `ExchGroupRteTemplateCmxFut`
) 
VALUES(
    'Example_accnt',
    'Example_clientFirm',
    'None',
    'Example_omniAccnt',
    'Example_omniAccnt2',
    'Example_clientAccnt',
    'dummy text',
    'dummy text',
    'Example_accntName',
    'Example_proxyFirm1',
    'Example_proxyFirm2',
    'Example_proxyFirm3',
    'Example_clientMPID',
    'Example_internalMPID',
    'Example_execBrkrCode',
    'Example_execBrkrAccountStk',
    'Example_execBrkrClFirmStk',
    'Example_execBrkrAccountFut',
    'Example_execBrkrClFirmFut',
    'Example_execBrkrAccountOpt',
    'Example_execBrkrClFirmOpt',
    'Example_reviewBrkrExDestStk',
    'Example_reviewBrkrExDestFut',
    'Example_reviewBrkrExDestOpt',
    'Example_execUserNameStk',
    'Example_execUserNameFut',
    'Example_execUserNameOpt',
    'Example_clearingFirmName',
    'Example_clearingFirmStk',
    'Example_clearingAccntStk',
    'Example_clearingFirmFut',
    'Example_clearingAccntFut',
    'Example_clearingFirmOpt',
    'Example_clearingAccntOpt',
    'Example_clearingFlipTypeOpt',
    'Example_clearingFlipFirmOpt',
    'Example_clearingFlipAccntOpt',
    'None',
    'None',
    'None',
    'Example_theoModel',
    'Example_theoModel2',
    'Example_priStkAggGroup',
    'Example_secStkAggGroup',
    'Example_optAggGroup',
    'Example_futAggGroup',
    'Example_accntColor',
    'None',
    'Example_defaultTradingAccnt',
    'Example_mifidAccntId',
    '2022-01-01',
    'Example_noCrossGroup',
    'None',
    1.23,
    'None',
    'None',
    'None',
    'None',
    'None',
    'Example_reviewExDest',
    'None',
    'None',
    'Example_locateFirm',
    'Example_locatePool',
    'None',
    'None',
    'None',
    'None',
    'None',
    'None',
    'Example_catAccnt',
    'Example_catBrkrAccnt',
    'None',
    'None',
    'Example_catBrkrIMID',
    'Loose',
    1,
    1,
    'None',
    'dummy tiny text',
    'dummy tiny text',
    'None',
    'None',
    'None',
    'None',
    'None',
    'None',
    'None',
    'None',
    'Example_billingSchedule',
    'dummy text',
    'Example_accountConfigRiskTemplate',
    'Example_ExchGroupCapStratTemplateNmsEqt',
    'Example_ExchGroupCapStratTemplateNmsOpt',
    'Example_ExchGroupCapStratTemplateCmxFut',
    'Example_ExchGroupRteTemplateNmsEqt',
    'Example_ExchGroupRteTemplateNmsOpt',
    'Example_ExchGroupRteTemplateCmxFut'
);

DELETE TABLE EXAMPLE QUERY

DELETE FROM `SRConfigGateway`.`MsgAccountConfigGateway` 
WHERE
    /* Replace with a VARCHAR(16) */ 
    `accnt` = 'Example_accnt'
  AND
    /* Replace with a VARCHAR(16) */ 
    `clientFirm` = 'Example_clientFirm';

Doc Columns Query

SELECT * FROM SRConfigGateway.doccolumns WHERE TABLE_NAME='AccountConfigGateway' ORDER BY ordinal_position ASC;

METADATA​

Table Definition​

PRIMARY KEY DEFINITION (Unique)​

SELECT TABLE EXAMPLE QUERY​

UPDATE TABLE EXAMPLE QUERY​

INSERT TABLE EXAMPLE QUERY​

DELETE TABLE EXAMPLE QUERY​

Doc Columns Query​

METADATA

Table Definition

PRIMARY KEY DEFINITION (Unique)

SELECT TABLE EXAMPLE QUERY

UPDATE TABLE EXAMPLE QUERY

INSERT TABLE EXAMPLE QUERY

DELETE TABLE EXAMPLE QUERY

Doc Columns Query